Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	17416
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.4 MiB
Average record size in memory	144.0 B

Variable types

DateTime	1
Numeric	11
Categorical	6

Alerts

`temp` is highly overall correlated with `dwpt` and 4 other fields	High correlation
`dwpt` is highly overall correlated with `temp` and 3 other fields	High correlation
`rhum` is highly overall correlated with `temp` and 1 other fields	High correlation
`hour_sin` is highly overall correlated with `is_night` and 1 other fields	High correlation
`hour_cos` is highly overall correlated with `is_night` and 1 other fields	High correlation
`month_sin` is highly overall correlated with `temp` and 3 other fields	High correlation
`month_cos` is highly overall correlated with `temp` and 4 other fields	High correlation
`lockdown2` is highly overall correlated with `season`	High correlation
`season` is highly overall correlated with `temp` and 5 other fields	High correlation
`is_night` is highly overall correlated with `hour_sin` and 1 other fields	High correlation
`lockdown1` is highly overall correlated with `season`	High correlation
`prcp` has 15318 (88.0%) zeros	Zeros
`hour_sin` has 728 (4.2%) zeros	Zeros

Reproduction

Analysis started	2022-11-29 16:35:39.568939
Analysis finished	2022-11-29 16:36:28.654545
Duration	49.09 seconds
Software version	pandas-profiling vv3.5.0
Download configuration	config.json

date
Date

Distinct	8750
Distinct (%)	50.2%
Missing	0
Missing (%)	0.0%
Memory size	136.2 KiB

Minimum	2020-01-01 00:00:00
Maximum	2022-01-01 22:00:00

Histogram

Histogram with fixed size bins (bins=50)

temp
Real number (ℝ)

Distinct	424
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.23444

Minimum	-6.4
Maximum	38.8
Zeros	10
Zeros (%)	0.1%
Negative	209
Negative (%)	1.2%
Memory size	136.2 KiB

Quantile statistics

Minimum	-6.4
5-th percentile	3.1
Q1	8.1
median	12.7
Q3	18.1
95-th percentile	25.1
Maximum	38.8
Range	45.2
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	6.8724803
Coefficient of variation (CV)	0.5192876
Kurtosis	-0.2540642
Mean	13.23444
Median Absolute Deviation (MAD)	4.9
Skewness	0.30449152
Sum	230491
Variance	47.230986
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.7	125	0.7%
8.2	123	0.7%
8.8	122	0.7%
8	120	0.7%
9.8	118	0.7%
9.1	115	0.7%
8.5	111	0.6%
9.2	110	0.6%
10.3	109	0.6%
8.9	109	0.6%
Other values (414)	16254	93.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6.4	1	< 0.1%
-6.3	1	< 0.1%
-6.1	3	< 0.1%
-6	2	< 0.1%
-5.9	2	< 0.1%
-5.7	2	< 0.1%
-5.5	1	< 0.1%
-5.4	1	< 0.1%
-5.3	1	< 0.1%
-5.2	3	< 0.1%

Value	Count	Frequency (%)
38.8	1	< 0.1%
38.7	2	< 0.1%
38.3	1	< 0.1%
38.2	1	< 0.1%
38.1	1	< 0.1%
37.5	1	< 0.1%
37.3	1	< 0.1%
37.2	1	< 0.1%
37	1	< 0.1%
36.7	1	< 0.1%

dwpt
Real number (ℝ)

Distinct	350
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.2219626

Minimum	-17.1
Maximum	22.6
Zeros	71
Zeros (%)	0.4%
Negative	1504
Negative (%)	8.6%
Memory size	136.2 KiB

Quantile statistics

Minimum	-17.1
5-th percentile	-1.6
Q1	3.4
median	7.4
Q3	11.4
95-th percentile	15.5
Maximum	22.6
Range	39.7
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.4700887
Coefficient of variation (CV)	0.75742413
Kurtosis	0.16176853
Mean	7.2219626
Median Absolute Deviation (MAD)	4
Skewness	-0.38718837
Sum	125777.7
Variance	29.92187
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7	150	0.9%
6.5	145	0.8%
6.2	141	0.8%
6.9	138	0.8%
5.7	137	0.8%
6.4	133	0.8%
8.3	132	0.8%
7.7	132	0.8%
6.1	131	0.8%
8.5	130	0.7%
Other values (340)	16047	92.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-17.1	1	< 0.1%
-16.3	1	< 0.1%
-16.1	1	< 0.1%
-15.9	1	< 0.1%
-15.5	1	< 0.1%
-15	1	< 0.1%
-14.8	1	< 0.1%
-14.7	1	< 0.1%
-14.5	1	< 0.1%
-14.1	1	< 0.1%

Value	Count	Frequency (%)
22.6	1	< 0.1%
21.5	1	< 0.1%
20.9	1	< 0.1%
20.8	1	< 0.1%
20.7	1	< 0.1%
20.3	1	< 0.1%
20.1	1	< 0.1%
20	3	< 0.1%
19.8	4	< 0.1%
19.7	4	< 0.1%

rhum
Real number (ℝ)

Distinct	83
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69.789102

Minimum	17
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	136.2 KiB

Quantile statistics

Minimum	17
5-th percentile	37
Q1	57
median	73
Q3	84
95-th percentile	93
Maximum	100
Range	83
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	17.50213
Coefficient of variation (CV)	0.25078601
Kurtosis	-0.54826941
Mean	69.789102
Median Absolute Deviation (MAD)	13
Skewness	-0.54654029
Sum	1215447
Variance	306.32457
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
81	444	2.5%
78	432	2.5%
80	429	2.5%
84	408	2.3%
88	407	2.3%
82	400	2.3%
85	400	2.3%
75	399	2.3%
79	398	2.3%
87	392	2.3%
Other values (73)	13307	76.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17	1	< 0.1%
19	4	< 0.1%
20	8	< 0.1%
21	12	0.1%
22	19	0.1%
23	15	0.1%
24	28	0.2%
25	26	0.1%
26	28	0.2%
27	34	0.2%

Value	Count	Frequency (%)
100	2	< 0.1%
99	23	0.1%
98	60	0.3%
97	108	0.6%
96	168	1.0%
95	186	1.1%
94	245	1.4%
93	354	2.0%
92	364	2.1%
91	353	2.0%

prcp
Real number (ℝ)

Distinct	43
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.092403537

Minimum	0
Maximum	18
Zeros	15318
Zeros (%)	88.0%
Negative	0
Negative (%)	0.0%
Memory size	136.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.4
Maximum	18
Range	18
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.53781413
Coefficient of variation (CV)	5.8202765
Kurtosis	424.70743
Mean	0.092403537
Median Absolute Deviation (MAD)	0
Skewness	16.754174
Sum	1609.3
Variance	0.28924404
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
0	15318	88.0%
0.2	636	3.7%
0.4	278	1.6%
0.1	262	1.5%
0.6	179	1.0%
1	166	1.0%
0.8	148	0.8%
2	105	0.6%
0.3	65	0.4%
3	53	0.3%
Other values (33)	206	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15318	88.0%
0.1	262	1.5%
0.2	636	3.7%
0.3	65	0.4%
0.4	278	1.6%
0.5	47	0.3%
0.6	179	1.0%
0.7	23	0.1%
0.8	148	0.8%
0.9	17	0.1%

Value	Count	Frequency (%)
18	2	< 0.1%
17	3	< 0.1%
16	1	< 0.1%
11	3	< 0.1%
10	1	< 0.1%
9	3	< 0.1%
8	1	< 0.1%
7	3	< 0.1%
6	3	< 0.1%
5.1	1	< 0.1%

wdir
Real number (ℝ)

Distinct	116
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	185.78026

Minimum	0
Maximum	360
Zeros	40
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	136.2 KiB

Quantile statistics

Minimum	0
5-th percentile	20
Q1	80
median	210
Q3	260
95-th percentile	340
Maximum	360
Range	360
Interquartile range (IQR)	180

Descriptive statistics

Standard deviation	102.27287
Coefficient of variation (CV)	0.55050452
Kurtosis	-1.0776468
Mean	185.78026
Median Absolute Deviation (MAD)	70
Skewness	-0.22861904
Sum	3235549
Variance	10459.74
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
220	1102	6.3%
210	974	5.6%
200	881	5.1%
230	844	4.8%
30	841	4.8%
190	763	4.4%
40	731	4.2%
50	646	3.7%
260	606	3.5%
280	573	3.3%
Other values (106)	9455	54.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	40	0.2%
10	465	2.7%
20	526	3.0%
23	1	< 0.1%
25	1	< 0.1%
26	2	< 0.1%
27	2	< 0.1%
28	2	< 0.1%
29	1	< 0.1%
30	841	4.8%

Value	Count	Frequency (%)
360	430	2.5%
350	333	1.9%
346	1	< 0.1%
344	1	< 0.1%
343	1	< 0.1%
340	356	2.0%
337	1	< 0.1%
333	1	< 0.1%
332	1	< 0.1%
330	468	2.7%

wspd
Real number (ℝ)

Distinct	65
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.307677

Minimum	0
Maximum	44.6
Zeros	40
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	136.2 KiB

Quantile statistics

Minimum	0
5-th percentile	3.6
Q1	7.6
median	11.2
Q3	14.8
95-th percentile	20.5
Maximum	44.6
Range	44.6
Interquartile range (IQR)	7.2

Descriptive statistics

Standard deviation	5.2922299
Coefficient of variation (CV)	0.46802097
Kurtosis	1.3978596
Mean	11.307677
Median Absolute Deviation (MAD)	3.6
Skewness	0.86633274
Sum	196934.5
Variance	28.007697
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.4	2560	14.7%
7.6	2396	13.8%
11.2	2257	13.0%
5.4	2236	12.8%
13	1981	11.4%
14.8	1599	9.2%
16.6	1106	6.4%
18.4	913	5.2%
3.6	907	5.2%
20.5	455	2.6%
Other values (55)	1006	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	40	0.2%
1.8	141	0.8%
3.6	907	5.2%
4.7	1	< 0.1%
5.4	2236	12.8%
5.8	1	< 0.1%
6.5	1	< 0.1%
6.8	1	< 0.1%
7.6	2396	13.8%
7.9	2	< 0.1%

Value	Count	Frequency (%)
44.6	1	< 0.1%
42.5	1	< 0.1%
40.7	5	< 0.1%
38.9	5	< 0.1%
37.1	5	< 0.1%
35.6	1	< 0.1%
35.3	6	< 0.1%
33.5	16	0.1%
31.7	31	0.2%
29.5	44	0.3%

pres
Real number (ℝ)

Distinct	624
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1017.0269

Minimum	972.2
Maximum	1047.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	136.2 KiB

Quantile statistics

Minimum	972.2
5-th percentile	1000.4
Q1	1012
median	1017.9
Q3	1023.1
95-th percentile	1030.5
Maximum	1047.8
Range	75.6
Interquartile range (IQR)	11.1

Descriptive statistics

Standard deviation	9.2914833
Coefficient of variation (CV)	0.0091359268
Kurtosis	1.1378415
Mean	1017.0269
Median Absolute Deviation (MAD)	5.6
Skewness	-0.58327778
Sum	17712540
Variance	86.331661
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1021	109	0.6%
1018.7	105	0.6%
1021.3	102	0.6%
1021.2	99	0.6%
1019.9	98	0.6%
1022	98	0.6%
1021.7	97	0.6%
1017.9	97	0.6%
1020.4	97	0.6%
1017.8	96	0.6%
Other values (614)	16418	94.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
972.2	1	< 0.1%
972.5	1	< 0.1%
972.7	1	< 0.1%
973.4	1	< 0.1%
973.6	1	< 0.1%
974.1	1	< 0.1%
974.8	1	< 0.1%
975.6	1	< 0.1%
975.9	2	< 0.1%
976.1	1	< 0.1%

Value	Count	Frequency (%)
1047.8	1	< 0.1%
1047.6	1	< 0.1%
1047.4	1	< 0.1%
1047.1	1	< 0.1%
1047	1	< 0.1%
1046.9	1	< 0.1%
1046.6	1	< 0.1%
1046.5	3	< 0.1%
1046.4	1	< 0.1%
1046.2	2	< 0.1%

holiday
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	136.2 KiB

0	16865
1	551

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	17416
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	16865	96.8%
1	551	3.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	16865	96.8%
1	551	3.2%

Most occurring characters

Value	Count	Frequency (%)
0	16865	96.8%
1	551	3.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17416	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16865	96.8%
1	551	3.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	17416	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16865	96.8%
1	551	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17416	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16865	96.8%
1	551	3.2%

weekend
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	136.2 KiB

0	12436
1	4980

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	17416
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	12436	71.4%
1	4980	28.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	12436	71.4%
1	4980	28.6%

Most occurring characters

Value	Count	Frequency (%)
0	12436	71.4%
1	4980	28.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17416	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	12436	71.4%
1	4980	28.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	17416	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	12436	71.4%
1	4980	28.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17416	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	12436	71.4%
1	4980	28.6%

lockdown1
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	136.2 KiB

0	16684
1	732

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	17416
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	16684	95.8%
1	732	4.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	16684	95.8%
1	732	4.2%

Most occurring characters

Value	Count	Frequency (%)
0	16684	95.8%
1	732	4.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17416	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16684	95.8%
1	732	4.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	17416	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16684	95.8%
1	732	4.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17416	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16684	95.8%
1	732	4.2%

lockdown2
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	136.2 KiB

0	15256
1	2160

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	17416
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	15256	87.6%
1	2160	12.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	15256	87.6%
1	2160	12.4%

Most occurring characters

Value	Count	Frequency (%)
0	15256	87.6%
1	2160	12.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17416	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	15256	87.6%
1	2160	12.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	17416	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	15256	87.6%
1	2160	12.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17416	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	15256	87.6%
1	2160	12.4%

season
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	136.2 KiB

1	5844
3	5807
0	2921
2	2844

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	17416
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	3
4th row	3
5th row	3

Common Values

Value	Count	Frequency (%)
1	5844	33.6%
3	5807	33.3%
0	2921	16.8%
2	2844	16.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	5844	33.6%
3	5807	33.3%
0	2921	16.8%
2	2844	16.3%

Most occurring characters

Value	Count	Frequency (%)
1	5844	33.6%
3	5807	33.3%
0	2921	16.8%
2	2844	16.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17416	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	5844	33.6%
3	5807	33.3%
0	2921	16.8%
2	2844	16.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	17416	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	5844	33.6%
3	5807	33.3%
0	2921	16.8%
2	2844	16.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17416	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	5844	33.6%
3	5807	33.3%
0	2921	16.8%
2	2844	16.3%

is_night
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	136.2 KiB

0	10157
1	7259

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	17416
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	10157	58.3%
1	7259	41.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	10157	58.3%
1	7259	41.7%

Most occurring characters

Value	Count	Frequency (%)
0	10157	58.3%
1	7259	41.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17416	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	10157	58.3%
1	7259	41.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	17416	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	10157	58.3%
1	7259	41.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17416	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	10157	58.3%
1	7259	41.7%

hour_sin
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.00013185883

Minimum	-0.99766877
Maximum	0.99766877
Zeros	728
Zeros (%)	4.2%
Negative	8706
Negative (%)	50.0%
Memory size	136.2 KiB

Quantile statistics

Minimum	-0.99766877
5-th percentile	-0.97908409
Q1	-0.73083596
median	0
Q3	0.63108794
95-th percentile	0.97908409
Maximum	0.99766877
Range	1.9953375
Interquartile range (IQR)	1.3619239

Descriptive statistics

Standard deviation	0.69223038
Coefficient of variation (CV)	-5249.7841
Kurtosis	-1.4346213
Mean	-0.00013185883
Median Absolute Deviation (MAD)	0.73083596
Skewness	-5.7033512 × 10^-5
Sum	-2.2964533
Variance	0.4791829
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	728	4.2%
-0.9422609221	728	4.2%
0.51958395	727	4.2%
0.8878852184	727	4.2%
0.1361666491	727	4.2%
0.2697967712	727	4.2%
-0.816969893	726	4.2%
-0.2697967712	726	4.2%
0.9790840877	726	4.2%
-0.8878852184	726	4.2%
Other values (14)	10148	58.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.9976687692	726	4.2%
-0.9790840877	726	4.2%
-0.9422609221	728	4.2%
-0.8878852184	726	4.2%
-0.816969893	726	4.2%
-0.7308359643	725	4.2%
-0.6310879443	724	4.2%
-0.51958395	723	4.2%
-0.3984010898	726	4.2%
-0.2697967712	726	4.2%

Value	Count	Frequency (%)
0.9976687692	724	4.2%
0.9790840877	726	4.2%
0.9422609221	725	4.2%
0.8878852184	727	4.2%
0.816969893	725	4.2%
0.7308359643	725	4.2%
0.6310879443	725	4.2%
0.51958395	727	4.2%
0.3984010898	724	4.2%
0.2697967712	727	4.2%

hour_cos
Real number (ℝ)

Distinct	21
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0419091

Minimum	-0.99068595
Maximum	1
Zeros	0
Zeros (%)	0.0%
Negative	8705
Negative (%)	50.0%
Memory size	136.2 KiB

Quantile statistics

Minimum	-0.99068595
5-th percentile	-0.99068595
Q1	-0.57668032
median	0.20345601
Q3	0.8544194
95-th percentile	1
Maximum	1
Range	1.9906859
Interquartile range (IQR)	1.4310997

Descriptive statistics

Standard deviation	0.72049846
Coefficient of variation (CV)	17.191934
Kurtosis	-1.5172311
Mean	0.0419091
Median Absolute Deviation (MAD)	0.70521233
Skewness	-0.062753693
Sum	729.88888
Variance	0.51911804
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	1453	8.3%
0.8544194045	1450	8.3%
0.6825531432	1450	8.3%
-0.3348796122	728	4.2%
0.4600650377	727	4.2%
0.9629172873	727	4.2%
-0.990685946	727	4.2%
-0.9172113015	726	4.2%
0.4600650377	726	4.2%
0.2034560131	726	4.2%
Other values (11)	7976	45.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.990685946	725	4.2%
-0.990685946	727	4.2%
-0.9172113015	724	4.2%
-0.9172113015	726	4.2%
-0.7757112907	724	4.2%
-0.7757112907	725	4.2%
-0.5766803221	726	4.2%
-0.5766803221	725	4.2%
-0.3348796122	728	4.2%
-0.3348796122	725	4.2%

Value	Count	Frequency (%)
1	1453	8.3%
0.9629172873	727	4.2%
0.9629172873	726	4.2%
0.8544194045	1450	8.3%
0.6825531432	1450	8.3%
0.4600650377	727	4.2%
0.4600650377	726	4.2%
0.2034560131	726	4.2%
0.2034560131	726	4.2%
-0.06824241336	726	4.2%

month_sin
Real number (ℝ)

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.0028627867

Minimum	-1
Maximum	1
Zeros	0
Zeros (%)	0.0%
Negative	8738
Negative (%)	50.2%
Memory size	136.2 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-0.8660254
median	-2.4492936 × 10^-16
Q3	0.5
95-th percentile	1
Maximum	1
Range	2
Interquartile range (IQR)	1.3660254

Descriptive statistics

Standard deviation	0.70645103
Coefficient of variation (CV)	-246.7704
Kurtosis	-1.4967009
Mean	-0.0028627867
Median Absolute Deviation (MAD)	0.5
Skewness	0.0023620223
Sum	-49.858293
Variance	0.49907306
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0.5	2967	17.0%
-0.8660254038	1488	8.5%
-2.449293598 × 10^-16	1488	8.5%
-0.5	1486	8.5%
-0.8660254038	1480	8.5%
1	1474	8.5%
-1	1440	8.3%
1.224646799 × 10^-16	1438	8.3%
0.8660254038	1434	8.2%
0.8660254038	1365	7.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	1440	8.3%
-0.8660254038	1488	8.5%
-0.8660254038	1480	8.5%
-0.5	1356	7.8%
-0.5	1486	8.5%
-2.449293598 × 10^-16	1488	8.5%
1.224646799 × 10^-16	1438	8.3%
0.5	2967	17.0%
0.8660254038	1365	7.8%
0.8660254038	1434	8.2%

Value	Count	Frequency (%)
1	1474	8.5%
0.8660254038	1434	8.2%
0.8660254038	1365	7.8%
0.5	2967	17.0%
1.224646799 × 10^-16	1438	8.3%
-2.449293598 × 10^-16	1488	8.5%
-0.5	1486	8.5%
-0.5	1356	7.8%
-0.8660254038	1480	8.5%
-0.8660254038	1488	8.5%

month_cos
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.0056927814

Minimum	-1
Maximum	1
Zeros	0
Zeros (%)	0.0%
Negative	8765
Negative (%)	50.3%
Memory size	136.2 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-0.8660254
median	-1.8369702 × 10^-16
Q3	0.5
95-th percentile	1
Maximum	1
Range	2
Interquartile range (IQR)	1.3660254

Descriptive statistics

Standard deviation	0.70777381
Coefficient of variation (CV)	-124.3283
Kurtosis	-1.5001526
Mean	-0.0056927814
Median Absolute Deviation (MAD)	0.8660254
Skewness	0.016583533
Sum	-99.14548
Variance	0.50094376
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0.5	1488	8.5%
1	1488	8.5%
-0.8660254038	1487	8.5%
-0.8660254038	1486	8.5%
0.8660254038	1480	8.5%
-0.5	1480	8.5%
6.123233996 × 10^-17	1474	8.5%
-1.836970199 × 10^-16	1440	8.3%
-1	1438	8.3%
-0.5	1434	8.2%
Other values (2)	2721	15.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	1438	8.3%
-0.8660254038	1486	8.5%
-0.8660254038	1487	8.5%
-0.5	1480	8.5%
-0.5	1434	8.2%
-1.836970199 × 10^-16	1440	8.3%
6.123233996 × 10^-17	1474	8.5%
0.5	1488	8.5%
0.5	1365	7.8%
0.8660254038	1356	7.8%

Value	Count	Frequency (%)
1	1488	8.5%
0.8660254038	1480	8.5%
0.8660254038	1356	7.8%
0.5	1365	7.8%
0.5	1488	8.5%
6.123233996 × 10^-17	1474	8.5%
-1.836970199 × 10^-16	1440	8.3%
-0.5	1434	8.2%
-0.5	1480	8.5%
-0.8660254038	1487	8.5%

Auto

The auto setting is an interpretable pairwise column metric of the following mapping:

Variable_type-Variable_type : Method, Range
Categorical-Categorical : Cramer's V, [0,1]
Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
Numerical-Numerical : Spearman's ρ, [-1,1]

The number of bins used in the discretization for the Numerical-Categorical column pair can be changed using config.correlations["auto"].n_bins. The number of bins affects the granularity of the association you wish to measure.

This configuration uses the recommended metric for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	date	temp	dwpt	rhum	wdir	wspd	pres	holiday	season	is_night	hour_sin	hour_cos	month_sin	month_cos
0	2020-01-01 00:00:00	0.8	-0.1	94	170.0	5.4	1032.5	1	3	1	0.000000	1.000000	0.5	0.866025
1	2020-01-01 02:00:00	-0.7	-1.3	96	200.0	9.4	1032.2	1	3	1	0.269797	0.962917	0.5	0.866025
2	2020-01-01 04:00:00	-0.3	-0.6	98	190.0	7.6	1032.2	1	3	1	0.519584	0.854419	0.5	0.866025
3	2020-01-01 06:00:00	0.0	-0.3	98	220.0	5.4	1031.9	1	3	1	0.730836	0.682553	0.5	0.866025
4	2020-01-01 08:00:00	0.3	0.0	98	210.0	7.6	1031.6	1	3	1	0.887885	0.460065	0.5	0.866025
5	2020-01-01 10:00:00	0.5	0.2	98	170.0	3.6	1031.9	1	3	1	0.979084	0.203456	0.5	0.866025
6	2020-01-01 12:00:00	0.7	0.4	98	160.0	5.4	1031.9	1	3	0	0.997669	-0.068242	0.5	0.866025
7	2020-01-01 14:00:00	0.8	0.5	98	170.0	11.2	1031.9	1	3	0	0.942261	-0.334880	0.5	0.866025
8	2020-01-01 16:00:00	1.0	0.7	98	160.0	11.2	1032.2	1	3	0	0.816970	-0.576680	0.5	0.866025
9	2020-01-01 18:00:00	1.4	1.3	99	160.0	11.2	1032.5	1	3	0	0.631088	-0.775711	0.5	0.866025

	date	temp	dwpt	rhum	wdir	wspd	pres	season	is_night	hour_sin	hour_cos	month_sin	month_cos
17406	2022-01-01 04:00:00	15.2	10.6	74	220.0	9.4	1023.1	3	0	-6.310879e-01	-0.775711	-2.449294e-16	1.0
17407	2022-01-01 06:00:00	15.4	11.0	75	210.0	7.6	1023.6	3	0	-8.169699e-01	-0.576680	-2.449294e-16	1.0
17408	2022-01-01 08:00:00	14.4	10.8	79	220.0	11.2	1024.3	3	0	-9.422609e-01	-0.334880	-2.449294e-16	1.0
17409	2022-01-01 10:00:00	13.3	10.8	85	220.0	7.6	1025.1	3	0	-9.976688e-01	-0.068242	-2.449294e-16	1.0
17410	2022-01-01 12:00:00	12.9	10.8	87	200.0	9.4	1025.5	3	0	-9.790841e-01	0.203456	-2.449294e-16	1.0
17411	2022-01-01 14:00:00	11.9	10.3	90	250.0	5.4	1026.5	3	0	-8.878852e-01	0.460065	-2.449294e-16	1.0
17412	2022-01-01 16:00:00	12.0	10.6	91	280.0	11.2	1026.6	3	1	-7.308360e-01	0.682553	-2.449294e-16	1.0
17413	2022-01-01 18:00:00	12.2	10.9	92	280.0	7.6	1026.6	3	1	-5.195840e-01	0.854419	-2.449294e-16	1.0
17414	2022-01-01 20:00:00	12.0	10.6	91	270.0	3.6	1026.7	3	1	-2.697968e-01	0.962917	-2.449294e-16	1.0
17415	2022-01-01 22:00:00	11.8	10.5	92	190.0	9.4	1026.6	3	1	-2.449294e-16	1.000000	-2.449294e-16	1.0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII